package com.ruoyi.SuveryInterface.Imp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.SuveryInterface.Imp.domain.SysCommercial;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author author
 * @since 2024-07-03
 */
public interface SysCommercialMapper extends BaseMapper<SysCommercial> {


    void insertSysCommercial(SysCommercial commercialEntity);

    @Select("select id,code,`result`,result_msg as `resultMsg`, out_trade_no as outTradeNo, tran_amt as tranAmt, tran_time as tranTime, sign ,report_id as reportId ,order_id as orderId ,create_time as createTime, update_time as updateTime from sys_commercial where order_id = #{orderId}")
    List<SysCommercial> selectSysCommercialByOrderId(Long orderId);
}
